0a06ba4d810f8911a0c56a44703a983326916a39,tests/frontend/org/voltdb/regressionsuites/TestFunctionsSuite.java,TestFunctionsSuite,testCaseWhen,#,2675
Before Change
sql = "SELECT ID, CASE WHEN num < 3 THEN num/2 ELSE num + 10 END FROM R1 ORDER BY 1;";
vt = cl.callProcedure("@AdHoc", sql).getResults()[0];
assertEquals(VoltType.INTEGER, vt.getColumnType(1));
if (isHSQL()) {
validateTableOfLongs(vt, new long[][] {{1, 0},{2, 15}, {3, 18}, {4, 0}});
} else {
validateTableOfLongs(vt, new long[][] {{1, 0},{2, 15}, {3, 18}, {4, Long.MIN_VALUE}});
}
}
After Change
sql = "SELECT ID, CASE WHEN num < 3 THEN num/2 ELSE num + 10 END FROM R1 ORDER BY 1;";
vt = cl.callProcedure("@AdHoc", sql).getResults()[0];
assertEquals(VoltType.INTEGER, vt.getColumnType(1));
validateTableOfLongs(vt, new long[][] {{1, 0},{2, 15}, {3, 18}, {4, Long.MIN_VALUE}});
}